> > "You say nextval() + write, I say write + currval()..."
>
>So long as a given application does not mix the two approaches, everything
>should be fine.
Though, if you have multiple clients inserting into the table, there
is a chance that between client A inserting the record and then
calling currval(), client B could have performed an insert, in which
case client A gets the value of client B's record. 'nextval() +
write' avoids this possible overlap.
--
Joel Stevenson
Bear River Associates, Inc.